import importlib.util

def load_module_from_path(path, module_name):
    """
    Load a Python module from a given file path.

    Args:
        path (str): The file path of the module to load.
        module_name (str): The name to give to the loaded module.

    Returns:
        module: The loaded Python module.

    Raises:
        ImportError: If the module cannot be loaded or executed.

    Example:
        >>> module = load_module_from_path('/path/to/module.py', 'custom_module')
        >>> # Now you can use the loaded module
        >>> module.some_function()
    """
    import logging
    logger = logging.getLogger(__name__)
    
    logger.info(f"Loading module {module_name} from path {path}")
    spec = importlib.util.spec_from_file_location(module_name, path)
    module = importlib.util.module_from_spec(spec)
    spec.loader.exec_module(module)
    logger.info(f"Successfully loaded module {module_name}")
    return module
